package com.ctvit.sms.platform.domain;
import java.util.Date;
import com.ctvit.framework.domain.BaseBean;
/**
* domain类
* 对应查询语句  SELECT 
    t_mobph.f_user_id,
    t_mobph.f_user_id AS f_mobph,
    person.z_perna
FROM
    ((SELECT 
        cgroup_sub.f_user_id
    FROM
        msdb.t_cmsg_group AS cgroup
    LEFT JOIN msdb.t_cmsg_group_sub AS cgroup_sub ON cgroup.f_group_id = cgroup_sub.f_group_id
    WHERE
        LENGTH(cgroup_sub.f_user_id) = 11
            AND cgroup.f_create_user_ID = '00213030') 
    UNION (SELECT 
        cretrieve.F_GET_USERS_ID AS f_user_id
    FROM
        msdb.t_cmsg_meeting AS meeting
    LEFT JOIN msdb.t_cmsg_retrieve AS cretrieve ON meeting.f_message_pk = cretrieve.f_message_pk
    WHERE
        cretrieve.f_type = 1
            AND LENGTH(cretrieve.F_GET_USERS_ID) = 11
            AND meeting.f_put_userid = '00213030') 
    UNION (SELECT 
        cretrieve.F_GET_USERS_ID AS f_user_id
    FROM
        msdb.t_cmsg_text AS cmsgtext
    LEFT JOIN msdb.t_cmsg_retrieve AS cretrieve ON cmsgtext.f_message_pk = cretrieve.f_message_pk
    WHERE
        cretrieve.f_type = 0
            AND LENGTH(cretrieve.F_GET_USERS_ID) = 11
            AND cmsgtext.f_put_userid = '00213030')) AS t_mobph
        LEFT JOIN
    msdb.t_person AS person ON t_mobph.f_user_id = person.z_perno
* 
*/ 
public class AddedOutsidePerson extends BaseBean{
	/*
	* 字段:     f_user_id 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String userId;
	/*
	* 字段:     f_mobph 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String mobph;
	/*
	* 字段:     z_perna 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String zPerna;
	
	/**
	 * null.
	 *
	 * @return UserId type:String
	 */
	public String getUserId() {
		return userId;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setUserId(String newvalue) {
		this.userId = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return Mobph type:String
	 */
	public String getMobph() {
		return mobph;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMobph(String newvalue) {
		this.mobph = newvalue;
	}
	
	/**
	 * null.
	 *
	 * @return ZPerna type:String
	 */
	public String getZPerna() {
		return zPerna;
	}
	
	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setZPerna(String newvalue) {
		this.zPerna = newvalue;
	}
}

